<?php

require_once 'propel/map/MapBuilder.php';
include_once 'creole/CreoleTypes.php';


/**
 * This class adds structure of 'HR_JOBS' table to 'workflow' DatabaseMap object.
 *
 *
 *
 * These statically-built map classes are used by Propel to do runtime db structure discovery.
 * For example, the createSelectSql() method checks the type of a given column used in an
 * ORDER BY clause to know whether it needs to apply SQL to make the ORDER BY case-insensitive
 * (i.e. if it's a text column type).
 *
 * @package    workflow.classes.model.map
 */
class HrJobsMapBuilder {

	/**
	 * The (dot-path) name of this class
	 */
	const CLASS_NAME = 'classes.model.map.HrJobsMapBuilder';

	/**
	 * The database map.
	 */
	private $dbMap;

	/**
	 * Tells us if this DatabaseMapBuilder is built so that we
	 * don't have to re-build it every time.
	 *
	 * @return     boolean true if this DatabaseMapBuilder is built, false otherwise.
	 */
	public function isBuilt()
	{
		return ($this->dbMap !== null);
	}

	/**
	 * Gets the databasemap this map builder built.
	 *
	 * @return     the databasemap
	 */
	public function getDatabaseMap()
	{
		return $this->dbMap;
	}

	/**
	 * The doBuild() method builds the DatabaseMap
	 *
	 * @return     void
	 * @throws     PropelException
	 */
	public function doBuild()
	{
		$this->dbMap = Propel::getDatabaseMap('workflow');

		$tMap = $this->dbMap->addTable('HR_JOBS');
		$tMap->setPhpName('HrJobs');

		$tMap->setUseIdGenerator(false);

		$tMap->addPrimaryKey('JOB_UID', 'JobUid', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('EMPLOYEE_ID', 'EmployeeId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('POSITION_ID', 'PositionId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('BOARDHIREDATE', 'Boardhiredate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('TYPEOFAPPOINTMENT_ID', 'TypeofappointmentId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('TYPEEMPLOYEE_ID', 'TypeemployeeId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('JOBTITLE_ID', 'JobtitleId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('TYPEPAY_ID', 'TypepayId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('FTE', 'Fte', 'double', CreoleTypes::DECIMAL, true, 10);

		$tMap->addColumn('PRIMARYIRN', 'Primaryirn', 'string', CreoleTypes::VARCHAR, true, 20);

		$tMap->addColumn('SPREADPAY', 'Spreadpay', 'string', CreoleTypes::CHAR, true, 1);

		$tMap->addColumn('OTHERPAY', 'Otherpay', 'double', CreoleTypes::DECIMAL, true, 10);

		$tMap->addColumn('LOCATIONIRN', 'Locationirn', 'string', CreoleTypes::VARCHAR, true, 255);

		$tMap->addColumn('JOBASSIGNMENT', 'Jobassignment', 'string', CreoleTypes::VARCHAR, true, 255);

		$tMap->addColumn('JOBSTATUS_ID', 'JobstatusId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('TERMINATIONDATE', 'Terminationdate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('PROJECTTERMINATIONDATE', 'Projectterminationdate', 'int', CreoleTypes::DATE, false, null);

		$tMap->addColumn('PAYUNIT_ID', 'PayunitId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('UNITAMOUNT', 'Unitamount', 'double', CreoleTypes::DECIMAL, true, 10);

		$tMap->addColumn('PAYPLAN_ID', 'PayplanId', 'string', CreoleTypes::VARCHAR, true, 32);

		$tMap->addColumn('HOURSINDAY', 'Hoursinday', 'double', CreoleTypes::DECIMAL, true, 10);

		$tMap->addColumn('DAYSINPERIOD', 'Daysinperiod', 'double', CreoleTypes::DECIMAL, true, 10);

		$tMap->addColumn('NUMBEROFPAYS', 'Numberofpays', 'int', CreoleTypes::INTEGER, true, null);

		$tMap->addColumn('FUNCTIONS', 'Functions', 'string', CreoleTypes::VARCHAR, true, 255);

		$tMap->addColumn('FUND', 'Fund', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('OBJECT', 'Object', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('OPU', 'Opu', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('SPECIALCOSTCENTER', 'Specialcostcenter', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('SUBJECT', 'Subject', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('FUNDSOURCECODE1', 'Fundsourcecode1', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('FUNDSOURCECODE1P', 'Fundsourcecode1p', 'double', CreoleTypes::DECIMAL, true, 5);

		$tMap->addColumn('FUNDSOURCECODE2', 'Fundsourcecode2', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('FUNDSOURCECODE2P', 'Fundsourcecode2p', 'double', CreoleTypes::DECIMAL, true, 5);

		$tMap->addColumn('FUNDSOURCECODE3', 'Fundsourcecode3', 'string', CreoleTypes::VARCHAR, true, 10);

		$tMap->addColumn('FUNDSOURCECODE3P', 'Fundsourcecode3p', 'double', CreoleTypes::DECIMAL, true, 5);

		$tMap->addColumn('INSTRUCTIONALLEVEL', 'Instructionallevel', 'string', CreoleTypes::VARCHAR, true, 50);

	} // doBuild()

} // HrJobsMapBuilder
